SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


create procedure dbo.DnnProduct_GetHtmlTextUser

@UserID int

as

select DnnProduct_HtmlTextUsers.*,
       DnnProduct_WorkflowStates.StateName
from   dbo.DnnProduct_HtmlTextUsers
inner join dbo.DnnProduct_WorkflowStates on dbo.DnnProduct_HtmlTextUsers.StateID = dbo.DnnProduct_WorkflowStates.StateID
where  DnnProduct_HtmlTextUsers.UserID = @UserID
order by DnnProduct_HtmlTextUsers.CreatedOnDate asc

GO
